90

Beginner’s Guide to Code Algorithms

90

STORE

TYPE

COLOR

SIZE

NUMBER SOLD

First Street

Mickey

red

L

300

First Street

Mickey

blue

S

100

First Street

Mickey

green

M

200

First Street

Mickey

black

L

300

First Street

Wonderland

navy

S

300

First Street

Wonderland

red

M

100

First Street

Wonderland

blue

L

200

The second Street Store wasn’t so lucky and their sales were summarized in only

five lines:

STORE

TYPE

COLOR

SIZE

NUMBER SOLD

Second Street

Wonderland

red

S

100

Second Street

Sandy

blue

M

100

Second Street

Sandy

green

L

200

Second Street

Sandy

black

S

300

Second Street

Sandy

navy

M

100

Once you receive all the stores, you want to collate them into one spreadsheet.

The manual steps to do that are the following:

Step 1: Open a new spreadsheet

Step 2: Copy store 1 from row 1

Step 3: Copy store 2 from row 13, but do not copy the header

Step 4: Copy store 3 from row 19 but do not copy header

:

:

Step 101: Save spreadsheet

The final worksheet looks something like this:

STORE

TYPE

COLOR

SIZE

NUMBER SOLD

First Street

Goofey

red

S

300

First Street

Goofey

blue

M

100

First Street

Goofey

green

L

200

First Street

Goofey

black

S

300

First Street

Goofey

navy

M

100

First Street

Mickey

red

L

300

First Street

Mickey

blue

S

100

First Street

Mickey

green

M

200

First Street

Mickey

black

L

300

First Street

Wonderland

navy

S

300

First Street

Wonderland

red

M

100

First Street

Wonderland

blue

L

200